Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 538837 |
| Missing cells | 2713637 |
| Missing cells (%) | 16.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 127.4 MiB |
| Average record size in memory | 248.0 B |
Variable types
| Numeric | 20 |
|---|---|
| Categorical | 5 |
| Text | 6 |
CANCELLED is highly imbalanced (86.4%) | Imbalance |
DIVERTED is highly imbalanced (97.5%) | Imbalance |
DEP_TIME has 9978 (1.9%) missing values | Missing |
DEP_DELAY has 9982 (1.9%) missing values | Missing |
TAXI_OUT has 10197 (1.9%) missing values | Missing |
TAXI_IN has 10519 (2.0%) missing values | Missing |
ARR_TIME has 10519 (2.0%) missing values | Missing |
ARR_DELAY has 11640 (2.2%) missing values | Missing |
CANCELLATION_CODE has 528542 (98.1%) missing values | Missing |
AIR_TIME has 11640 (2.2%) missing values | Missing |
CARRIER_DELAY has 422124 (78.3%) missing values | Missing |
WEATHER_DELAY has 422124 (78.3%) missing values | Missing |
NAS_DELAY has 422124 (78.3%) missing values | Missing |
SECURITY_DELAY has 422124 (78.3%) missing values | Missing |
LATE_AIRCRAFT_DELAY has 422124 (78.3%) missing values | Missing |
SECURITY_DELAY is highly skewed (γ1 = 34.44878616) | Skewed |
DEP_DELAY has 23846 (4.4%) zeros | Zeros |
ARR_DELAY has 9345 (1.7%) zeros | Zeros |
CARRIER_DELAY has 53559 (9.9%) zeros | Zeros |
WEATHER_DELAY has 110206 (20.5%) zeros | Zeros |
NAS_DELAY has 57001 (10.6%) zeros | Zeros |
SECURITY_DELAY has 116087 (21.5%) zeros | Zeros |
LATE_AIRCRAFT_DELAY has 62630 (11.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-30 05:35:14.686200 |
|---|---|
| Analysis finished | 2024-03-30 05:38:07.899917 |
| Duration | 2 minutes and 53.21 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
DAY_OF_WEEK
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.8902692 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.07623 |
|---|---|
| Coefficient of variation (CV) | 0.53369827 |
| Kurtosis | -1.3106465 |
| Mean | 3.8902692 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.09438584 |
| Sum | 2096221 |
| Variance | 4.3107308 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 1 | 90875 | |
| 7 | 86695 | |
| 2 | 86270 | |
| 5 | 72554 | |
| 4 | 72392 | |
| 3 | 68901 | |
| 6 | 61150 |
| Value | Count | Frequency (%) |
| 1 | 90875 | |
| 2 | 86270 | |
| 3 | 68901 | |
| 4 | 72392 | |
| 5 | 72554 | |
| 6 | 61150 | |
| 7 | 86695 |
| Value | Count | Frequency (%) |
| 7 | 86695 | |
| 6 | 61150 | |
| 5 | 72554 | |
| 4 | 72392 | |
| 3 | 68901 | |
| 2 | 86270 | |
| 1 | 90875 |
FL_DATE
Categorical
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
| 1/27/2023 12:00:00 AM | 18539 |
|---|---|
| 1/26/2023 12:00:00 AM | 18519 |
| 1/20/2023 12:00:00 AM | 18506 |
| 1/19/2023 12:00:00 AM | 18472 |
| 1/13/2023 12:00:00 AM | 18422 |
| Other values (26) |
Length
| Max length | 21 |
|---|---|
| Median length | 21 |
| Mean length | 20.713631 |
| Min length | 20 |
Characters and Unicode
| Total characters | 11161271 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1/2/2023 12:00:00 AM |
|---|---|
| 2nd row | 1/2/2023 12:00:00 AM |
| 3rd row | 1/2/2023 12:00:00 AM |
| 4th row | 1/2/2023 12:00:00 AM |
| 5th row | 1/2/2023 12:00:00 AM |
Common Values
| Value | Count | Frequency (%) |
| 1/27/2023 12:00:00 AM | 18539 | 3.4% |
| 1/26/2023 12:00:00 AM | 18519 | 3.4% |
| 1/20/2023 12:00:00 AM | 18506 | 3.4% |
| 1/19/2023 12:00:00 AM | 18472 | 3.4% |
| 1/13/2023 12:00:00 AM | 18422 | 3.4% |
| 1/12/2023 12:00:00 AM | 18380 | 3.4% |
| 1/9/2023 12:00:00 AM | 18233 | 3.4% |
| 1/30/2023 12:00:00 AM | 18201 | 3.4% |
| 1/23/2023 12:00:00 AM | 18185 | 3.4% |
| 1/16/2023 12:00:00 AM | 18181 | 3.4% |
| Other values (21) | 355199 |
Length
| Value | Count | Frequency (%) |
| 12:00:00 | 538837 | |
| am | 538837 | |
| 1/27/2023 | 18539 | 1.1% |
| 1/26/2023 | 18519 | 1.1% |
| 1/20/2023 | 18506 | 1.1% |
| 1/19/2023 | 18472 | 1.1% |
| 1/13/2023 | 18422 | 1.1% |
| 1/12/2023 | 18380 | 1.1% |
| 1/9/2023 | 18233 | 1.1% |
| 1/30/2023 | 18201 | 1.1% |
| Other values (23) | 391565 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2747960 | |
| 2 | 1846135 | |
| 1 | 1317349 | |
| / | 1077674 | 9.7% |
| 1077674 | 9.7% | |
| : | 1077674 | 9.7% |
| 3 | 628509 | 5.6% |
| A | 538837 | 4.8% |
| M | 538837 | 4.8% |
| 9 | 54785 | 0.5% |
| Other values (5) | 255837 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11161271 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2747960 | |
| 2 | 1846135 | |
| 1 | 1317349 | |
| / | 1077674 | 9.7% |
| 1077674 | 9.7% | |
| : | 1077674 | 9.7% |
| 3 | 628509 | 5.6% |
| A | 538837 | 4.8% |
| M | 538837 | 4.8% |
| 9 | 54785 | 0.5% |
| Other values (5) | 255837 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11161271 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2747960 | |
| 2 | 1846135 | |
| 1 | 1317349 | |
| / | 1077674 | 9.7% |
| 1077674 | 9.7% | |
| : | 1077674 | 9.7% |
| 3 | 628509 | 5.6% |
| A | 538837 | 4.8% |
| M | 538837 | 4.8% |
| 9 | 54785 | 0.5% |
| Other values (5) | 255837 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11161271 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2747960 | |
| 2 | 1846135 | |
| 1 | 1317349 | |
| / | 1077674 | 9.7% |
| 1077674 | 9.7% | |
| : | 1077674 | 9.7% |
| 3 | 628509 | 5.6% |
| A | 538837 | 4.8% |
| M | 538837 | 4.8% |
| 9 | 54785 | 0.5% |
| Other values (5) | 255837 | 2.3% |
OP_UNIQUE_CARRIER
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
| WN | |
|---|---|
| DL | |
| AA | |
| UA | |
| OO | |
| Other values (10) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1077674 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9E |
|---|---|
| 2nd row | 9E |
| 3rd row | 9E |
| 4th row | 9E |
| 5th row | 9E |
Common Values
| Value | Count | Frequency (%) |
| WN | 112430 | |
| DL | 75174 | |
| AA | 74999 | |
| UA | 56657 | |
| OO | 50347 | |
| YX | 24476 | 4.5% |
| B6 | 23249 | 4.3% |
| NK | 21876 | 4.1% |
| AS | 19801 | 3.7% |
| MQ | 18849 | 3.5% |
| Other values (5) | 60979 |
Length
| Value | Count | Frequency (%) |
| wn | 112430 | |
| dl | 75174 | |
| aa | 74999 | |
| ua | 56657 | |
| oo | 50347 | |
| yx | 24476 | 4.5% |
| b6 | 23249 | 4.3% |
| nk | 21876 | 4.1% |
| as | 19801 | 3.7% |
| mq | 18849 | 3.5% |
| Other values (5) | 60979 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 233153 | |
| N | 134306 | |
| O | 116150 | |
| W | 112430 | |
| D | 75174 | 7.0% |
| L | 75174 | 7.0% |
| U | 56657 | 5.3% |
| 9 | 30211 | 2.8% |
| Y | 24476 | 2.3% |
| X | 24476 | 2.3% |
| Other values (11) | 195467 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1077674 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 233153 | |
| N | 134306 | |
| O | 116150 | |
| W | 112430 | |
| D | 75174 | 7.0% |
| L | 75174 | 7.0% |
| U | 56657 | 5.3% |
| 9 | 30211 | 2.8% |
| Y | 24476 | 2.3% |
| X | 24476 | 2.3% |
| Other values (11) | 195467 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1077674 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 233153 | |
| N | 134306 | |
| O | 116150 | |
| W | 112430 | |
| D | 75174 | 7.0% |
| L | 75174 | 7.0% |
| U | 56657 | 5.3% |
| 9 | 30211 | 2.8% |
| Y | 24476 | 2.3% |
| X | 24476 | 2.3% |
| Other values (11) | 195467 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1077674 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 233153 | |
| N | 134306 | |
| O | 116150 | |
| W | 112430 | |
| D | 75174 | 7.0% |
| L | 75174 | 7.0% |
| U | 56657 | 5.3% |
| 9 | 30211 | 2.8% |
| Y | 24476 | 2.3% |
| X | 24476 | 2.3% |
| Other values (11) | 195467 |
OP_CARRIER_FL_NUM
Real number (ℝ)
| Distinct | 5874 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2201.9296 |
| Minimum | 1 |
|---|---|
| Maximum | 9887 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 266 |
| Q1 | 972 |
| median | 1909 |
| Q3 | 3056 |
| 95-th percentile | 5302 |
| Maximum | 9887 |
| Range | 9886 |
| Interquartile range (IQR) | 2084 |
Descriptive statistics
| Standard deviation | 1547.1982 |
|---|---|
| Coefficient of variation (CV) | 0.7026556 |
| Kurtosis | -0.41816017 |
| Mean | 2201.9296 |
| Median Absolute Deviation (MAD) | 1021 |
| Skewness | 0.71418849 |
| Sum | 1.1864811 × 109 |
| Variance | 2393822.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 710 | 313 | 0.1% |
| 568 | 304 | 0.1% |
| 354 | 303 | 0.1% |
| 311 | 300 | 0.1% |
| 1168 | 295 | 0.1% |
| 2005 | 289 | 0.1% |
| 366 | 286 | 0.1% |
| 312 | 282 | 0.1% |
| 531 | 281 | 0.1% |
| 2274 | 279 | 0.1% |
| Other values (5864) | 535905 |
| Value | Count | Frequency (%) |
| 1 | 142 | |
| 2 | 185 | |
| 3 | 193 | |
| 4 | 193 | |
| 5 | 84 | |
| 6 | 109 | |
| 7 | 116 | |
| 8 | 94 | |
| 9 | 86 | |
| 10 | 154 |
| Value | Count | Frequency (%) |
| 9887 | 1 | |
| 9768 | 1 | |
| 8819 | 1 | |
| 8818 | 1 | |
| 8815 | 1 | |
| 8812 | 2 | |
| 8810 | 2 | |
| 8809 | 1 | |
| 8808 | 2 | |
| 8807 | 2 |
ORIGIN_AIRPORT_ID
Real number (ℝ)
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12653.203 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1524.1973 |
|---|---|
| Coefficient of variation (CV) | 0.1204594 |
| Kurtosis | -1.2937249 |
| Mean | 12653.203 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.099030674 |
| Sum | 6.818014 × 109 |
| Variance | 2323177.3 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10397 | 26582 | 4.9% |
| 11292 | 22460 | 4.2% |
| 11298 | 20502 | 3.8% |
| 13930 | 20086 | 3.7% |
| 12889 | 15792 | 2.9% |
| 12892 | 15424 | 2.9% |
| 11057 | 15170 | 2.8% |
| 14107 | 14613 | 2.7% |
| 12953 | 13479 | 2.5% |
| 13204 | 13333 | 2.5% |
| Other values (329) | 361396 |
| Value | Count | Frequency (%) |
| 10135 | 300 | 0.1% |
| 10136 | 107 | < 0.1% |
| 10140 | 1690 | |
| 10141 | 61 | < 0.1% |
| 10146 | 82 | < 0.1% |
| 10155 | 96 | < 0.1% |
| 10157 | 142 | < 0.1% |
| 10158 | 221 | < 0.1% |
| 10165 | 8 | < 0.1% |
| 10170 | 50 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 107 | < 0.1% |
| 16218 | 90 | < 0.1% |
| 15991 | 60 | < 0.1% |
| 15919 | 866 | |
| 15841 | 60 | < 0.1% |
| 15624 | 473 | |
| 15607 | 82 | < 0.1% |
| 15582 | 51 | < 0.1% |
| 15569 | 58 | < 0.1% |
| 15412 | 925 |
ORIGIN
Text
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1616511 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BDL |
|---|---|
| 2nd row | DLH |
| 3rd row | ORF |
| 4th row | MSP |
| 5th row | PIT |
| Value | Count | Frequency (%) |
| atl | 26582 | 4.9% |
| den | 22460 | 4.2% |
| dfw | 20502 | 3.8% |
| ord | 20086 | 3.7% |
| las | 15792 | 2.9% |
| lax | 15424 | 2.9% |
| clt | 15170 | 2.8% |
| phx | 14613 | 2.7% |
| lga | 13479 | 2.5% |
| mco | 13333 | 2.5% |
| Other values (329) | 361396 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 186296 | 11.5% |
| L | 151614 | 9.4% |
| S | 138357 | 8.6% |
| D | 124019 | 7.7% |
| T | 85072 | 5.3% |
| O | 82063 | 5.1% |
| C | 81602 | 5.0% |
| M | 71680 | 4.4% |
| F | 64963 | 4.0% |
| P | 62456 | 3.9% |
| Other values (16) | 568389 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1616511 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 186296 | 11.5% |
| L | 151614 | 9.4% |
| S | 138357 | 8.6% |
| D | 124019 | 7.7% |
| T | 85072 | 5.3% |
| O | 82063 | 5.1% |
| C | 81602 | 5.0% |
| M | 71680 | 4.4% |
| F | 64963 | 4.0% |
| P | 62456 | 3.9% |
| Other values (16) | 568389 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1616511 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 186296 | 11.5% |
| L | 151614 | 9.4% |
| S | 138357 | 8.6% |
| D | 124019 | 7.7% |
| T | 85072 | 5.3% |
| O | 82063 | 5.1% |
| C | 81602 | 5.0% |
| M | 71680 | 4.4% |
| F | 64963 | 4.0% |
| P | 62456 | 3.9% |
| Other values (16) | 568389 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1616511 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 186296 | 11.5% |
| L | 151614 | 9.4% |
| S | 138357 | 8.6% |
| D | 124019 | 7.7% |
| T | 85072 | 5.3% |
| O | 82063 | 5.1% |
| C | 81602 | 5.0% |
| M | 71680 | 4.4% |
| F | 64963 | 4.0% |
| P | 62456 | 3.9% |
| Other values (16) | 568389 |
ORIGIN_CITY_NAME
Text
| Distinct | 333 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.003541 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7006789 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Hartford, CT |
|---|---|
| 2nd row | Duluth, MN |
| 3rd row | Norfolk, VA |
| 4th row | Minneapolis, MN |
| 5th row | Pittsburgh, PA |
| Value | Count | Frequency (%) |
| ca | 58708 | 4.7% |
| tx | 54592 | 4.3% |
| fl | 50713 | 4.0% |
| ny | 30887 | 2.5% |
| ga | 28431 | 2.3% |
| new | 28393 | 2.3% |
| san | 27845 | 2.2% |
| il | 27631 | 2.2% |
| chicago | 26584 | 2.1% |
| atlanta | 26582 | 2.1% |
| Other values (404) | 897785 |
Most occurring characters
| Value | Count | Frequency (%) |
| 719314 | 10.3% | |
| , | 538837 | 7.7% |
| a | 535724 | 7.6% |
| o | 383728 | 5.5% |
| e | 372247 | 5.3% |
| n | 343244 | 4.9% |
| t | 330328 | 4.7% |
| l | 303600 | 4.3% |
| i | 263079 | 3.8% |
| r | 252146 | 3.6% |
| Other values (46) | 2964542 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7006789 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 719314 | 10.3% | |
| , | 538837 | 7.7% |
| a | 535724 | 7.6% |
| o | 383728 | 5.5% |
| e | 372247 | 5.3% |
| n | 343244 | 4.9% |
| t | 330328 | 4.7% |
| l | 303600 | 4.3% |
| i | 263079 | 3.8% |
| r | 252146 | 3.6% |
| Other values (46) | 2964542 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7006789 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 719314 | 10.3% | |
| , | 538837 | 7.7% |
| a | 535724 | 7.6% |
| o | 383728 | 5.5% |
| e | 372247 | 5.3% |
| n | 343244 | 4.9% |
| t | 330328 | 4.7% |
| l | 303600 | 4.3% |
| i | 263079 | 3.8% |
| r | 252146 | 3.6% |
| Other values (46) | 2964542 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7006789 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 719314 | 10.3% | |
| , | 538837 | 7.7% |
| a | 535724 | 7.6% |
| o | 383728 | 5.5% |
| e | 372247 | 5.3% |
| n | 343244 | 4.9% |
| t | 330328 | 4.7% |
| l | 303600 | 4.3% |
| i | 263079 | 3.8% |
| r | 252146 | 3.6% |
| Other values (46) | 2964542 |
ORIGIN_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.137459 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4384764 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Connecticut |
|---|---|
| 2nd row | Minnesota |
| 3rd row | Virginia |
| 4th row | Minnesota |
| 5th row | Pennsylvania |
| Value | Count | Frequency (%) |
| california | 58708 | 9.5% |
| texas | 54592 | 8.8% |
| florida | 50713 | 8.2% |
| new | 45283 | 7.3% |
| york | 30887 | 5.0% |
| georgia | 28431 | 4.6% |
| illinois | 27631 | 4.5% |
| colorado | 25999 | 4.2% |
| carolina | 25698 | 4.2% |
| north | 23139 | 3.7% |
| Other values (51) | 247358 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 588608 | |
| i | 494644 | 11.3% |
| o | 423646 | 9.7% |
| r | 322603 | 7.4% |
| n | 318238 | 7.3% |
| e | 269553 | 6.1% |
| l | 244743 | 5.6% |
| s | 244019 | 5.6% |
| C | 112162 | 2.6% |
| d | 111047 | 2.5% |
| Other values (37) | 1255501 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4384764 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 588608 | |
| i | 494644 | 11.3% |
| o | 423646 | 9.7% |
| r | 322603 | 7.4% |
| n | 318238 | 7.3% |
| e | 269553 | 6.1% |
| l | 244743 | 5.6% |
| s | 244019 | 5.6% |
| C | 112162 | 2.6% |
| d | 111047 | 2.5% |
| Other values (37) | 1255501 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4384764 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 588608 | |
| i | 494644 | 11.3% |
| o | 423646 | 9.7% |
| r | 322603 | 7.4% |
| n | 318238 | 7.3% |
| e | 269553 | 6.1% |
| l | 244743 | 5.6% |
| s | 244019 | 5.6% |
| C | 112162 | 2.6% |
| d | 111047 | 2.5% |
| Other values (37) | 1255501 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4384764 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 588608 | |
| i | 494644 | 11.3% |
| o | 423646 | 9.7% |
| r | 322603 | 7.4% |
| n | 318238 | 7.3% |
| e | 269553 | 6.1% |
| l | 244743 | 5.6% |
| s | 244019 | 5.6% |
| C | 112162 | 2.6% |
| d | 111047 | 2.5% |
| Other values (37) | 1255501 |
ORIGIN_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.355763 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 33 |
| median | 44 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 49 |
Descriptive statistics
| Standard deviation | 26.919824 |
|---|---|
| Coefficient of variation (CV) | 0.49525244 |
| Kurtosis | -1.3294453 |
| Mean | 54.355763 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | -0.022303038 |
| Sum | 29288896 |
| Variance | 724.67692 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 91 | 58708 | 10.9% |
| 74 | 54592 | 10.1% |
| 33 | 50713 | 9.4% |
| 22 | 30887 | 5.7% |
| 34 | 28431 | 5.3% |
| 41 | 27631 | 5.1% |
| 82 | 25999 | 4.8% |
| 36 | 21736 | 4.0% |
| 38 | 18636 | 3.5% |
| 85 | 17395 | 3.2% |
| Other values (42) | 204109 |
| Value | Count | Frequency (%) |
| 1 | 2684 | 0.5% |
| 2 | 11037 | |
| 3 | 3126 | 0.6% |
| 4 | 581 | 0.1% |
| 5 | 104 | < 0.1% |
| 11 | 1757 | 0.3% |
| 12 | 995 | 0.2% |
| 13 | 11015 | |
| 14 | 507 | 0.1% |
| 15 | 1179 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 13640 | 2.5% |
| 92 | 5845 | 1.1% |
| 91 | 58708 | |
| 88 | 954 | 0.2% |
| 87 | 9421 | 1.7% |
| 86 | 1902 | 0.4% |
| 85 | 17395 | 3.2% |
| 84 | 1913 | 0.4% |
| 83 | 2230 | 0.4% |
| 82 | 25999 |
DEST_AIRPORT_ID
Real number (ℝ)
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12653.175 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1524.1464 |
|---|---|
| Coefficient of variation (CV) | 0.12045564 |
| Kurtosis | -1.2936425 |
| Mean | 12653.175 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.099123627 |
| Sum | 6.817999 × 109 |
| Variance | 2323022.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10397 | 26566 | 4.9% |
| 11292 | 22461 | 4.2% |
| 11298 | 20521 | 3.8% |
| 13930 | 20092 | 3.7% |
| 12889 | 15793 | 2.9% |
| 12892 | 15428 | 2.9% |
| 11057 | 15167 | 2.8% |
| 14107 | 14620 | 2.7% |
| 12953 | 13481 | 2.5% |
| 13204 | 13327 | 2.5% |
| Other values (329) | 361381 |
| Value | Count | Frequency (%) |
| 10135 | 298 | 0.1% |
| 10136 | 109 | < 0.1% |
| 10140 | 1689 | |
| 10141 | 61 | < 0.1% |
| 10146 | 82 | < 0.1% |
| 10155 | 96 | < 0.1% |
| 10157 | 143 | < 0.1% |
| 10158 | 220 | < 0.1% |
| 10165 | 8 | < 0.1% |
| 10170 | 51 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 107 | < 0.1% |
| 16218 | 90 | < 0.1% |
| 15991 | 60 | < 0.1% |
| 15919 | 865 | |
| 15841 | 60 | < 0.1% |
| 15624 | 473 | |
| 15607 | 82 | < 0.1% |
| 15582 | 51 | < 0.1% |
| 15569 | 59 | < 0.1% |
| 15412 | 924 |
DEST
Text
| Distinct | 339 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1616511 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LGA |
|---|---|
| 2nd row | MSP |
| 3rd row | DTW |
| 4th row | PIT |
| 5th row | MSP |
| Value | Count | Frequency (%) |
| atl | 26566 | 4.9% |
| den | 22461 | 4.2% |
| dfw | 20521 | 3.8% |
| ord | 20092 | 3.7% |
| las | 15793 | 2.9% |
| lax | 15428 | 2.9% |
| clt | 15167 | 2.8% |
| phx | 14620 | 2.7% |
| lga | 13481 | 2.5% |
| mco | 13327 | 2.5% |
| Other values (329) | 361381 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 186308 | 11.5% |
| L | 151565 | 9.4% |
| S | 138336 | 8.6% |
| D | 124055 | 7.7% |
| T | 85066 | 5.3% |
| O | 82052 | 5.1% |
| C | 81606 | 5.0% |
| M | 71675 | 4.4% |
| F | 64964 | 4.0% |
| P | 62465 | 3.9% |
| Other values (16) | 568419 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1616511 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 186308 | 11.5% |
| L | 151565 | 9.4% |
| S | 138336 | 8.6% |
| D | 124055 | 7.7% |
| T | 85066 | 5.3% |
| O | 82052 | 5.1% |
| C | 81606 | 5.0% |
| M | 71675 | 4.4% |
| F | 64964 | 4.0% |
| P | 62465 | 3.9% |
| Other values (16) | 568419 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1616511 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 186308 | 11.5% |
| L | 151565 | 9.4% |
| S | 138336 | 8.6% |
| D | 124055 | 7.7% |
| T | 85066 | 5.3% |
| O | 82052 | 5.1% |
| C | 81606 | 5.0% |
| M | 71675 | 4.4% |
| F | 64964 | 4.0% |
| P | 62465 | 3.9% |
| Other values (16) | 568419 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1616511 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 186308 | 11.5% |
| L | 151565 | 9.4% |
| S | 138336 | 8.6% |
| D | 124055 | 7.7% |
| T | 85066 | 5.3% |
| O | 82052 | 5.1% |
| C | 81606 | 5.0% |
| M | 71675 | 4.4% |
| F | 64964 | 4.0% |
| P | 62465 | 3.9% |
| Other values (16) | 568419 |
DEST_CITY_NAME
Text
| Distinct | 333 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.003663 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7006855 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York, NY |
|---|---|
| 2nd row | Minneapolis, MN |
| 3rd row | Detroit, MI |
| 4th row | Pittsburgh, PA |
| 5th row | Minneapolis, MN |
| Value | Count | Frequency (%) |
| ca | 58697 | 4.7% |
| tx | 54615 | 4.3% |
| fl | 50679 | 4.0% |
| ny | 30887 | 2.5% |
| ga | 28415 | 2.3% |
| new | 28395 | 2.3% |
| san | 27819 | 2.2% |
| il | 27635 | 2.2% |
| chicago | 26590 | 2.1% |
| atlanta | 26566 | 2.1% |
| Other values (404) | 897833 |
Most occurring characters
| Value | Count | Frequency (%) |
| 719294 | 10.3% | |
| , | 538837 | 7.7% |
| a | 535681 | 7.6% |
| o | 383748 | 5.5% |
| e | 372230 | 5.3% |
| n | 343220 | 4.9% |
| t | 330316 | 4.7% |
| l | 303605 | 4.3% |
| i | 263098 | 3.8% |
| r | 252149 | 3.6% |
| Other values (46) | 2964677 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7006855 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 719294 | 10.3% | |
| , | 538837 | 7.7% |
| a | 535681 | 7.6% |
| o | 383748 | 5.5% |
| e | 372230 | 5.3% |
| n | 343220 | 4.9% |
| t | 330316 | 4.7% |
| l | 303605 | 4.3% |
| i | 263098 | 3.8% |
| r | 252149 | 3.6% |
| Other values (46) | 2964677 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7006855 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 719294 | 10.3% | |
| , | 538837 | 7.7% |
| a | 535681 | 7.6% |
| o | 383748 | 5.5% |
| e | 372230 | 5.3% |
| n | 343220 | 4.9% |
| t | 330316 | 4.7% |
| l | 303605 | 4.3% |
| i | 263098 | 3.8% |
| r | 252149 | 3.6% |
| Other values (46) | 2964677 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7006855 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 719294 | 10.3% | |
| , | 538837 | 7.7% |
| a | 535681 | 7.6% |
| o | 383748 | 5.5% |
| e | 372230 | 5.3% |
| n | 343220 | 4.9% |
| t | 330316 | 4.7% |
| l | 303605 | 4.3% |
| i | 263098 | 3.8% |
| r | 252149 | 3.6% |
| Other values (46) | 2964677 |
DEST_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.137446 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4384757 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York |
|---|---|
| 2nd row | Minnesota |
| 3rd row | Michigan |
| 4th row | Pennsylvania |
| 5th row | Minnesota |
| Value | Count | Frequency (%) |
| california | 58697 | 9.5% |
| texas | 54615 | 8.8% |
| florida | 50679 | 8.2% |
| new | 45285 | 7.3% |
| york | 30887 | 5.0% |
| georgia | 28415 | 4.6% |
| illinois | 27635 | 4.5% |
| colorado | 26001 | 4.2% |
| carolina | 25704 | 4.2% |
| north | 23139 | 3.7% |
| Other values (51) | 247385 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 588590 | |
| i | 494643 | 11.3% |
| o | 423613 | 9.7% |
| r | 322570 | 7.4% |
| n | 318261 | 7.3% |
| e | 269579 | 6.1% |
| l | 244712 | 5.6% |
| s | 244084 | 5.6% |
| C | 112158 | 2.6% |
| d | 111006 | 2.5% |
| Other values (37) | 1255541 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4384757 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 588590 | |
| i | 494643 | 11.3% |
| o | 423613 | 9.7% |
| r | 322570 | 7.4% |
| n | 318261 | 7.3% |
| e | 269579 | 6.1% |
| l | 244712 | 5.6% |
| s | 244084 | 5.6% |
| C | 112158 | 2.6% |
| d | 111006 | 2.5% |
| Other values (37) | 1255541 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4384757 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 588590 | |
| i | 494643 | 11.3% |
| o | 423613 | 9.7% |
| r | 322570 | 7.4% |
| n | 318261 | 7.3% |
| e | 269579 | 6.1% |
| l | 244712 | 5.6% |
| s | 244084 | 5.6% |
| C | 112158 | 2.6% |
| d | 111006 | 2.5% |
| Other values (37) | 1255541 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4384757 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 588590 | |
| i | 494643 | 11.3% |
| o | 423613 | 9.7% |
| r | 322570 | 7.4% |
| n | 318261 | 7.3% |
| e | 269579 | 6.1% |
| l | 244712 | 5.6% |
| s | 244084 | 5.6% |
| C | 112158 | 2.6% |
| d | 111006 | 2.5% |
| Other values (37) | 1255541 |
DEST_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.358511 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 33 |
| median | 44 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 49 |
Descriptive statistics
| Standard deviation | 26.918285 |
|---|---|
| Coefficient of variation (CV) | 0.49519908 |
| Kurtosis | -1.3293716 |
| Mean | 54.358511 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | -0.022461321 |
| Sum | 29290377 |
| Variance | 724.59406 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 91 | 58697 | 10.9% |
| 74 | 54615 | 10.1% |
| 33 | 50679 | 9.4% |
| 22 | 30887 | 5.7% |
| 34 | 28415 | 5.3% |
| 41 | 27635 | 5.1% |
| 82 | 26001 | 4.8% |
| 36 | 21735 | 4.0% |
| 38 | 18651 | 3.5% |
| 85 | 17393 | 3.2% |
| Other values (42) | 204129 |
| Value | Count | Frequency (%) |
| 1 | 2687 | 0.5% |
| 2 | 11034 | |
| 3 | 3116 | 0.6% |
| 4 | 581 | 0.1% |
| 5 | 104 | < 0.1% |
| 11 | 1756 | 0.3% |
| 12 | 994 | 0.2% |
| 13 | 11014 | |
| 14 | 506 | 0.1% |
| 15 | 1179 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 13647 | 2.5% |
| 92 | 5844 | 1.1% |
| 91 | 58697 | |
| 88 | 954 | 0.2% |
| 87 | 9416 | 1.7% |
| 86 | 1901 | 0.4% |
| 85 | 17393 | 3.2% |
| 84 | 1911 | 0.4% |
| 83 | 2227 | 0.4% |
| 82 | 26001 |
CRS_DEP_TIME
Real number (ℝ)
| Distinct | 1212 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1327.4156 |
| Minimum | 5 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 600 |
| Q1 | 910 |
| median | 1320 |
| Q3 | 1732 |
| 95-th percentile | 2124 |
| Maximum | 2359 |
| Range | 2354 |
| Interquartile range (IQR) | 822 |
Descriptive statistics
| Standard deviation | 489.90267 |
|---|---|
| Coefficient of variation (CV) | 0.36906502 |
| Kurtosis | -1.0609794 |
| Mean | 1327.4156 |
| Median Absolute Deviation (MAD) | 410 |
| Skewness | 0.087268579 |
| Sum | 7.1526065 × 108 |
| Variance | 240004.63 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 600 | 12516 | 2.3% |
| 700 | 8737 | 1.6% |
| 800 | 5625 | 1.0% |
| 900 | 4034 | 0.7% |
| 630 | 3544 | 0.7% |
| 1000 | 3535 | 0.7% |
| 830 | 3298 | 0.6% |
| 1100 | 3289 | 0.6% |
| 730 | 3214 | 0.6% |
| 615 | 3121 | 0.6% |
| Other values (1202) | 487924 |
| Value | Count | Frequency (%) |
| 5 | 31 | |
| 6 | 4 | < 0.1% |
| 9 | 4 | < 0.1% |
| 12 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 14 | 32 | |
| 15 | 48 | |
| 16 | 6 | < 0.1% |
| 18 | 13 | < 0.1% |
| 19 | 22 |
| Value | Count | Frequency (%) |
| 2359 | 750 | |
| 2358 | 58 | < 0.1% |
| 2357 | 25 | < 0.1% |
| 2356 | 17 | < 0.1% |
| 2355 | 305 | |
| 2354 | 56 | < 0.1% |
| 2353 | 1 | < 0.1% |
| 2352 | 35 | < 0.1% |
| 2351 | 38 | < 0.1% |
| 2350 | 253 | < 0.1% |
DEP_TIME
Real number (ℝ)
MISSING 
| Distinct | 1407 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 9978 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1334.4419 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 559 |
| Q1 | 917 |
| median | 1327 |
| Q3 | 1743 |
| 95-th percentile | 2135 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 826 |
Descriptive statistics
| Standard deviation | 502.42772 |
|---|---|
| Coefficient of variation (CV) | 0.37650775 |
| Kurtosis | -0.99130698 |
| Mean | 1334.4419 |
| Median Absolute Deviation (MAD) | 413 |
| Skewness | 0.033588591 |
| Sum | 7.057316 × 108 |
| Variance | 252433.61 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 555 | 1492 | 0.3% |
| 556 | 1304 | 0.2% |
| 557 | 1225 | 0.2% |
| 554 | 1196 | 0.2% |
| 558 | 1134 | 0.2% |
| 559 | 1098 | 0.2% |
| 553 | 1090 | 0.2% |
| 600 | 1023 | 0.2% |
| 552 | 983 | 0.2% |
| 657 | 974 | 0.2% |
| Other values (1397) | 517340 | |
| (Missing) | 9978 | 1.9% |
| Value | Count | Frequency (%) |
| 1 | 66 | |
| 2 | 47 | |
| 3 | 40 | |
| 4 | 50 | |
| 5 | 55 | |
| 6 | 51 | |
| 7 | 39 | |
| 8 | 40 | |
| 9 | 36 | |
| 10 | 36 |
| Value | Count | Frequency (%) |
| 2400 | 48 | < 0.1% |
| 2359 | 87 | |
| 2358 | 86 | |
| 2357 | 82 | |
| 2356 | 85 | |
| 2355 | 92 | |
| 2354 | 100 | |
| 2353 | 88 | |
| 2352 | 121 | |
| 2351 | 104 |
DEP_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 1110 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 9982 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.937247 |
| Minimum | -52 |
|---|---|
| Maximum | 3024 |
| Zeros | 23846 |
| Zeros (%) | 4.4% |
| Negative | 302230 |
| Negative (%) | 56.1% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | -52 |
|---|---|
| 5-th percentile | -10 |
| Q1 | -6 |
| median | -2 |
| Q3 | 10 |
| 95-th percentile | 85 |
| Maximum | 3024 |
| Range | 3076 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 55.435948 |
|---|---|
| Coefficient of variation (CV) | 4.2849878 |
| Kurtosis | 223.07317 |
| Mean | 12.937247 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 11.022176 |
| Sum | 6841928 |
| Variance | 3073.1443 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -5 | 38269 | 7.1% |
| -4 | 35123 | 6.5% |
| -3 | 34216 | 6.3% |
| -2 | 30667 | 5.7% |
| -6 | 30519 | 5.7% |
| -1 | 27820 | 5.2% |
| -7 | 26264 | 4.9% |
| 0 | 23846 | 4.4% |
| -8 | 21797 | 4.0% |
| -9 | 16909 | 3.1% |
| Other values (1100) | 243425 |
| Value | Count | Frequency (%) |
| -52 | 1 | < 0.1% |
| -48 | 1 | < 0.1% |
| -45 | 1 | < 0.1% |
| -44 | 1 | < 0.1% |
| -42 | 2 | |
| -40 | 3 | |
| -39 | 1 | < 0.1% |
| -38 | 1 | < 0.1% |
| -37 | 3 | |
| -36 | 3 |
| Value | Count | Frequency (%) |
| 3024 | 1 | |
| 2669 | 1 | |
| 2554 | 1 | |
| 2250 | 1 | |
| 2168 | 1 | |
| 2130 | 1 | |
| 2047 | 1 | |
| 2036 | 1 | |
| 1933 | 1 | |
| 1875 | 1 |
TAXI_OUT
Real number (ℝ)
MISSING 
| Distinct | 171 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10197 |
| Missing (%) | 1.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.334566 |
| Minimum | 1 |
|---|---|
| Maximum | 222 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 12 |
| median | 15 |
| Q3 | 21 |
| 95-th percentile | 38 |
| Maximum | 222 |
| Range | 221 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 10.62446 |
|---|---|
| Coefficient of variation (CV) | 0.57947704 |
| Kurtosis | 17.85648 |
| Mean | 18.334566 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 3.1095996 |
| Sum | 9692385 |
| Variance | 112.87915 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 13 | 40421 | 7.5% |
| 12 | 40331 | 7.5% |
| 14 | 37888 | 7.0% |
| 11 | 37538 | 7.0% |
| 15 | 34404 | 6.4% |
| 10 | 30907 | 5.7% |
| 16 | 30311 | 5.6% |
| 17 | 26755 | 5.0% |
| 18 | 23214 | 4.3% |
| 9 | 22407 | 4.2% |
| Other values (161) | 204464 |
| Value | Count | Frequency (%) |
| 1 | 11 | < 0.1% |
| 2 | 17 | < 0.1% |
| 3 | 52 | < 0.1% |
| 4 | 213 | < 0.1% |
| 5 | 635 | 0.1% |
| 6 | 2803 | 0.5% |
| 7 | 7093 | 1.3% |
| 8 | 13524 | |
| 9 | 22407 | |
| 10 | 30907 |
| Value | Count | Frequency (%) |
| 222 | 1 | < 0.1% |
| 183 | 1 | < 0.1% |
| 180 | 1 | < 0.1% |
| 179 | 1 | < 0.1% |
| 175 | 1 | < 0.1% |
| 172 | 5 | |
| 170 | 2 | < 0.1% |
| 169 | 1 | < 0.1% |
| 165 | 1 | < 0.1% |
| 164 | 2 | < 0.1% |
TAXI_IN
Real number (ℝ)
MISSING 
| Distinct | 134 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10519 |
| Missing (%) | 2.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.0379998 |
| Minimum | 1 |
|---|---|
| Maximum | 173 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 19 |
| Maximum | 173 |
| Range | 172 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 6.4165741 |
|---|---|
| Coefficient of variation (CV) | 0.79827995 |
| Kurtosis | 35.166111 |
| Mean | 8.0379998 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 4.2395693 |
| Sum | 4246620 |
| Variance | 41.172423 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 79279 | |
| 5 | 75753 | |
| 6 | 63092 | |
| 7 | 50739 | |
| 3 | 48275 | |
| 8 | 39266 | |
| 9 | 30738 | 5.7% |
| 10 | 24016 | 4.5% |
| 11 | 18890 | 3.5% |
| 12 | 14646 | 2.7% |
| Other values (124) | 83624 |
| Value | Count | Frequency (%) |
| 1 | 689 | 0.1% |
| 2 | 11397 | 2.1% |
| 3 | 48275 | |
| 4 | 79279 | |
| 5 | 75753 | |
| 6 | 63092 | |
| 7 | 50739 | |
| 8 | 39266 | |
| 9 | 30738 | 5.7% |
| 10 | 24016 | 4.5% |
| Value | Count | Frequency (%) |
| 173 | 1 | < 0.1% |
| 163 | 1 | < 0.1% |
| 152 | 2 | |
| 150 | 1 | < 0.1% |
| 147 | 1 | < 0.1% |
| 142 | 1 | < 0.1% |
| 139 | 4 | |
| 138 | 1 | < 0.1% |
| 137 | 1 | < 0.1% |
| 136 | 1 | < 0.1% |
CRS_ARR_TIME
Real number (ℝ)
| Distinct | 1305 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1497.1776 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 728 |
| Q1 | 1109 |
| median | 1520 |
| Q3 | 1927 |
| 95-th percentile | 2257 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 818 |
Descriptive statistics
| Standard deviation | 515.23676 |
|---|---|
| Coefficient of variation (CV) | 0.3441387 |
| Kurtosis | -0.47236634 |
| Mean | 1497.1776 |
| Median Absolute Deviation (MAD) | 410 |
| Skewness | -0.28269901 |
| Sum | 8.0673471 × 108 |
| Variance | 265468.92 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2359 | 2259 | 0.4% |
| 1810 | 1863 | 0.3% |
| 1915 | 1704 | 0.3% |
| 1750 | 1687 | 0.3% |
| 2000 | 1574 | 0.3% |
| 1030 | 1553 | 0.3% |
| 1025 | 1544 | 0.3% |
| 1640 | 1539 | 0.3% |
| 1620 | 1535 | 0.3% |
| 1000 | 1510 | 0.3% |
| Other values (1295) | 522069 |
| Value | Count | Frequency (%) |
| 1 | 76 | < 0.1% |
| 2 | 50 | < 0.1% |
| 3 | 141 | < 0.1% |
| 4 | 105 | < 0.1% |
| 5 | 549 | |
| 6 | 91 | < 0.1% |
| 7 | 107 | < 0.1% |
| 8 | 181 | < 0.1% |
| 9 | 134 | < 0.1% |
| 10 | 334 |
| Value | Count | Frequency (%) |
| 2359 | 2259 | |
| 2358 | 552 | 0.1% |
| 2357 | 496 | 0.1% |
| 2356 | 505 | 0.1% |
| 2355 | 1001 | |
| 2354 | 379 | 0.1% |
| 2353 | 470 | 0.1% |
| 2352 | 312 | 0.1% |
| 2351 | 274 | 0.1% |
| 2350 | 681 | 0.1% |
ARR_TIME
Real number (ℝ)
MISSING 
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 10519 |
| Missing (%) | 2.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1475.3177 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 656 |
| Q1 | 1057 |
| median | 1512 |
| Q3 | 1922 |
| 95-th percentile | 2254 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 865 |
Descriptive statistics
| Standard deviation | 537.43003 |
|---|---|
| Coefficient of variation (CV) | 0.36428088 |
| Kurtosis | -0.32480644 |
| Mean | 1475.3177 |
| Median Absolute Deviation (MAD) | 412 |
| Skewness | -0.38509807 |
| Sum | 7.794369 × 108 |
| Variance | 288831.04 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1150 | 606 | 0.1% |
| 1647 | 604 | 0.1% |
| 1233 | 597 | 0.1% |
| 1152 | 590 | 0.1% |
| 1158 | 587 | 0.1% |
| 1854 | 586 | 0.1% |
| 1642 | 584 | 0.1% |
| 1544 | 583 | 0.1% |
| 1155 | 582 | 0.1% |
| 1840 | 581 | 0.1% |
| Other values (1430) | 522418 | |
| (Missing) | 10519 | 2.0% |
| Value | Count | Frequency (%) |
| 1 | 341 | |
| 2 | 266 | |
| 3 | 293 | |
| 4 | 283 | |
| 5 | 304 | |
| 6 | 282 | |
| 7 | 268 | |
| 8 | 285 | |
| 9 | 236 | |
| 10 | 264 |
| Value | Count | Frequency (%) |
| 2400 | 281 | |
| 2359 | 302 | |
| 2358 | 352 | |
| 2357 | 340 | |
| 2356 | 366 | |
| 2355 | 323 | |
| 2354 | 378 | |
| 2353 | 390 | |
| 2352 | 361 | |
| 2351 | 366 |
ARR_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 1136 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 11640 |
| Missing (%) | 2.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.7763929 |
| Minimum | -80 |
|---|---|
| Maximum | 3063 |
| Zeros | 9345 |
| Zeros (%) | 1.7% |
| Negative | 315277 |
| Negative (%) | 58.5% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | -80 |
|---|---|
| 5-th percentile | -28 |
| Q1 | -15 |
| median | -5 |
| Q3 | 11 |
| 95-th percentile | 85 |
| Maximum | 3063 |
| Range | 3143 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 57.396811 |
|---|---|
| Coefficient of variation (CV) | 7.3809042 |
| Kurtosis | 190.85869 |
| Mean | 7.7763929 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 9.8552167 |
| Sum | 4099691 |
| Variance | 3294.3939 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -12 | 13860 | 2.6% |
| -11 | 13830 | 2.6% |
| -10 | 13768 | 2.6% |
| -9 | 13384 | 2.5% |
| -13 | 13312 | 2.5% |
| -8 | 13304 | 2.5% |
| -14 | 13009 | 2.4% |
| -7 | 12944 | 2.4% |
| -6 | 12538 | 2.3% |
| -15 | 12515 | 2.3% |
| Other values (1126) | 394733 |
| Value | Count | Frequency (%) |
| -80 | 1 | < 0.1% |
| -78 | 1 | < 0.1% |
| -74 | 2 | < 0.1% |
| -73 | 1 | < 0.1% |
| -72 | 3 | |
| -69 | 3 | |
| -68 | 2 | < 0.1% |
| -67 | 6 | |
| -66 | 6 | |
| -65 | 6 |
| Value | Count | Frequency (%) |
| 3063 | 1 | |
| 2687 | 1 | |
| 2557 | 1 | |
| 2229 | 1 | |
| 2078 | 1 | |
| 2061 | 1 | |
| 2027 | 1 | |
| 1927 | 1 | |
| 1877 | 1 | |
| 1775 | 1 |
CANCELLED
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
| 0.0 | |
|---|---|
| 1.0 | 10295 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1616511 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 528542 | |
| 1.0 | 10295 | 1.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 528542 | |
| 1.0 | 10295 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1067379 | |
| . | 538837 | |
| 1 | 10295 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1616511 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1067379 | |
| . | 538837 | |
| 1 | 10295 | 0.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1616511 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1067379 | |
| . | 538837 | |
| 1 | 10295 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1616511 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1067379 | |
| . | 538837 | |
| 1 | 10295 | 0.6% |
CANCELLATION_CODE
Categorical
MISSING 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 528542 |
| Missing (%) | 98.1% |
| Memory size | 4.1 MiB |
| B | |
|---|---|
| C | |
| A | |
| D | 185 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 10295 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | B |
|---|---|
| 2nd row | B |
| 3rd row | C |
| 4th row | C |
| 5th row | C |
Common Values
| Value | Count | Frequency (%) |
| B | 6611 | 1.2% |
| C | 1792 | 0.3% |
| A | 1707 | 0.3% |
| D | 185 | < 0.1% |
| (Missing) | 528542 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| b | 6611 | |
| c | 1792 | 17.4% |
| a | 1707 | 16.6% |
| d | 185 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 6611 | |
| C | 1792 | 17.4% |
| A | 1707 | 16.6% |
| D | 185 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 10295 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 6611 | |
| C | 1792 | 17.4% |
| A | 1707 | 16.6% |
| D | 185 | 1.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 10295 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 6611 | |
| C | 1792 | 17.4% |
| A | 1707 | 16.6% |
| D | 185 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 10295 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 6611 | |
| C | 1792 | 17.4% |
| A | 1707 | 16.6% |
| D | 185 | 1.8% |
DIVERTED
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
| 0.0 | |
|---|---|
| 1.0 | 1345 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1616511 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 537492 | |
| 1.0 | 1345 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 537492 | |
| 1.0 | 1345 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1076329 | |
| . | 538837 | |
| 1 | 1345 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1616511 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1076329 | |
| . | 538837 | |
| 1 | 1345 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1616511 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1076329 | |
| . | 538837 | |
| 1 | 1345 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1616511 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1076329 | |
| . | 538837 | |
| 1 | 1345 | 0.1% |
AIR_TIME
Real number (ℝ)
MISSING 
| Distinct | 642 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 11640 |
| Missing (%) | 2.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 115.81437 |
| Minimum | 8 |
|---|---|
| Maximum | 695 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 36 |
| Q1 | 63 |
| median | 99 |
| Q3 | 146 |
| 95-th percentile | 271 |
| Maximum | 695 |
| Range | 687 |
| Interquartile range (IQR) | 83 |
Descriptive statistics
| Standard deviation | 71.811305 |
|---|---|
| Coefficient of variation (CV) | 0.62005525 |
| Kurtosis | 2.9615396 |
| Mean | 115.81437 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 1.48244 |
| Sum | 61056986 |
| Variance | 5156.8635 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 63 | 4435 | 0.8% |
| 65 | 4416 | 0.8% |
| 62 | 4404 | 0.8% |
| 61 | 4401 | 0.8% |
| 64 | 4401 | 0.8% |
| 60 | 4396 | 0.8% |
| 58 | 4366 | 0.8% |
| 66 | 4295 | 0.8% |
| 57 | 4267 | 0.8% |
| 59 | 4251 | 0.8% |
| Other values (632) | 483565 | |
| (Missing) | 11640 | 2.2% |
| Value | Count | Frequency (%) |
| 8 | 4 | < 0.1% |
| 9 | 16 | < 0.1% |
| 10 | 12 | < 0.1% |
| 11 | 7 | < 0.1% |
| 12 | 3 | < 0.1% |
| 13 | 6 | < 0.1% |
| 14 | 7 | < 0.1% |
| 15 | 30 | < 0.1% |
| 16 | 99 | |
| 17 | 155 |
| Value | Count | Frequency (%) |
| 695 | 1 | |
| 694 | 1 | |
| 688 | 1 | |
| 684 | 1 | |
| 677 | 1 | |
| 675 | 1 | |
| 673 | 1 | |
| 668 | 1 | |
| 666 | 1 | |
| 665 | 1 |
CARRIER_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 850 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 422124 |
| Missing (%) | 78.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.509343 |
| Minimum | 0 |
|---|---|
| Maximum | 3024 |
| Zeros | 53559 |
| Zeros (%) | 9.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3 |
| Q3 | 23 |
| 95-th percentile | 102.4 |
| Maximum | 3024 |
| Range | 3024 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 73.732581 |
|---|---|
| Coefficient of variation (CV) | 3.0083458 |
| Kurtosis | 188.46874 |
| Mean | 24.509343 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 10.817922 |
| Sum | 2860559 |
| Variance | 5436.4935 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 53559 | 9.9% |
| 15 | 1941 | 0.4% |
| 2 | 1775 | 0.3% |
| 6 | 1774 | 0.3% |
| 16 | 1747 | 0.3% |
| 3 | 1744 | 0.3% |
| 1 | 1716 | 0.3% |
| 7 | 1694 | 0.3% |
| 17 | 1652 | 0.3% |
| 4 | 1632 | 0.3% |
| Other values (840) | 47479 | 8.8% |
| (Missing) | 422124 |
| Value | Count | Frequency (%) |
| 0 | 53559 | |
| 1 | 1716 | 0.3% |
| 2 | 1775 | 0.3% |
| 3 | 1744 | 0.3% |
| 4 | 1632 | 0.3% |
| 5 | 1613 | 0.3% |
| 6 | 1774 | 0.3% |
| 7 | 1694 | 0.3% |
| 8 | 1611 | 0.3% |
| 9 | 1532 | 0.3% |
| Value | Count | Frequency (%) |
| 3024 | 1 | |
| 2669 | 1 | |
| 2554 | 1 | |
| 2229 | 1 | |
| 2078 | 1 | |
| 2047 | 1 | |
| 1875 | 1 | |
| 1807 | 1 | |
| 1775 | 1 | |
| 1740 | 1 |
WEATHER_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 537 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 422124 |
| Missing (%) | 78.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.3839675 |
| Minimum | 0 |
|---|---|
| Maximum | 1653 |
| Zeros | 110206 |
| Zeros (%) | 20.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 7 |
| Maximum | 1653 |
| Range | 1653 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 38.069314 |
|---|---|
| Coefficient of variation (CV) | 8.6837583 |
| Kurtosis | 448.4417 |
| Mean | 4.3839675 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 18.389964 |
| Sum | 511666 |
| Variance | 1449.2727 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 110206 | 20.5% |
| 15 | 132 | < 0.1% |
| 17 | 130 | < 0.1% |
| 20 | 123 | < 0.1% |
| 19 | 121 | < 0.1% |
| 16 | 116 | < 0.1% |
| 7 | 113 | < 0.1% |
| 6 | 112 | < 0.1% |
| 8 | 112 | < 0.1% |
| 9 | 109 | < 0.1% |
| Other values (527) | 5439 | 1.0% |
| (Missing) | 422124 |
| Value | Count | Frequency (%) |
| 0 | 110206 | |
| 1 | 104 | < 0.1% |
| 2 | 94 | < 0.1% |
| 3 | 96 | < 0.1% |
| 4 | 95 | < 0.1% |
| 5 | 88 | < 0.1% |
| 6 | 112 | < 0.1% |
| 7 | 113 | < 0.1% |
| 8 | 112 | < 0.1% |
| 9 | 109 | < 0.1% |
| Value | Count | Frequency (%) |
| 1653 | 1 | |
| 1496 | 1 | |
| 1482 | 1 | |
| 1418 | 1 | |
| 1415 | 1 | |
| 1397 | 1 | |
| 1369 | 1 | |
| 1364 | 1 | |
| 1217 | 1 | |
| 1163 | 1 |
NAS_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 397 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 422124 |
| Missing (%) | 78.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.648488 |
| Minimum | 0 |
|---|---|
| Maximum | 1343 |
| Zeros | 57001 |
| Zeros (%) | 10.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 18 |
| 95-th percentile | 62 |
| Maximum | 1343 |
| Range | 1343 |
| Interquartile range (IQR) | 18 |
Descriptive statistics
| Standard deviation | 32.531918 |
|---|---|
| Coefficient of variation (CV) | 2.2208379 |
| Kurtosis | 135.7771 |
| Mean | 14.648488 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 7.751564 |
| Sum | 1709669 |
| Variance | 1058.3257 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 57001 | 10.6% |
| 1 | 2825 | 0.5% |
| 15 | 2353 | 0.4% |
| 2 | 2080 | 0.4% |
| 16 | 2065 | 0.4% |
| 17 | 1962 | 0.4% |
| 3 | 1896 | 0.4% |
| 4 | 1783 | 0.3% |
| 18 | 1738 | 0.3% |
| 5 | 1717 | 0.3% |
| Other values (387) | 41293 | 7.7% |
| (Missing) | 422124 |
| Value | Count | Frequency (%) |
| 0 | 57001 | |
| 1 | 2825 | 0.5% |
| 2 | 2080 | 0.4% |
| 3 | 1896 | 0.4% |
| 4 | 1783 | 0.3% |
| 5 | 1717 | 0.3% |
| 6 | 1593 | 0.3% |
| 7 | 1615 | 0.3% |
| 8 | 1516 | 0.3% |
| 9 | 1443 | 0.3% |
| Value | Count | Frequency (%) |
| 1343 | 1 | |
| 1079 | 1 | |
| 1060 | 1 | |
| 1005 | 1 | |
| 968 | 1 | |
| 931 | 1 | |
| 926 | 1 | |
| 894 | 1 | |
| 867 | 1 | |
| 844 | 1 |
SECURITY_DELAY
Real number (ℝ)
MISSING  SKEWED  ZEROS 
| Distinct | 96 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 422124 |
| Missing (%) | 78.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.14624763 |
| Minimum | 0 |
|---|---|
| Maximum | 234 |
| Zeros | 116087 |
| Zeros (%) | 21.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 234 |
| Range | 234 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.8958323 |
|---|---|
| Coefficient of variation (CV) | 19.800883 |
| Kurtosis | 1658.0491 |
| Mean | 0.14624763 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 34.448786 |
| Sum | 17069 |
| Variance | 8.3858446 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 116087 | 21.5% |
| 6 | 27 | < 0.1% |
| 15 | 26 | < 0.1% |
| 18 | 25 | < 0.1% |
| 12 | 21 | < 0.1% |
| 10 | 21 | < 0.1% |
| 16 | 20 | < 0.1% |
| 8 | 20 | < 0.1% |
| 19 | 20 | < 0.1% |
| 20 | 18 | < 0.1% |
| Other values (86) | 428 | 0.1% |
| (Missing) | 422124 |
| Value | Count | Frequency (%) |
| 0 | 116087 | |
| 1 | 15 | < 0.1% |
| 2 | 12 | < 0.1% |
| 3 | 10 | < 0.1% |
| 4 | 11 | < 0.1% |
| 5 | 18 | < 0.1% |
| 6 | 27 | < 0.1% |
| 7 | 18 | < 0.1% |
| 8 | 20 | < 0.1% |
| 9 | 15 | < 0.1% |
| Value | Count | Frequency (%) |
| 234 | 1 | |
| 197 | 1 | |
| 192 | 1 | |
| 189 | 1 | |
| 168 | 2 | |
| 155 | 1 | |
| 139 | 1 | |
| 132 | 2 | |
| 122 | 1 | |
| 121 | 1 |
LATE_AIRCRAFT_DELAY
Real number (ℝ)
MISSING  ZEROS 
| Distinct | 615 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 422124 |
| Missing (%) | 78.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.755743 |
| Minimum | 0 |
|---|---|
| Maximum | 2027 |
| Zeros | 62630 |
| Zeros (%) | 11.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 29 |
| 95-th percentile | 122 |
| Maximum | 2027 |
| Range | 2027 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 57.507827 |
|---|---|
| Coefficient of variation (CV) | 2.2328157 |
| Kurtosis | 102.89642 |
| Mean | 25.755743 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.0764072 |
| Sum | 3006030 |
| Variance | 3307.1501 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 62630 | 11.6% |
| 15 | 1210 | 0.2% |
| 16 | 1172 | 0.2% |
| 17 | 1149 | 0.2% |
| 18 | 1107 | 0.2% |
| 19 | 1063 | 0.2% |
| 20 | 1008 | 0.2% |
| 21 | 966 | 0.2% |
| 14 | 909 | 0.2% |
| 13 | 907 | 0.2% |
| Other values (605) | 44592 | 8.3% |
| (Missing) | 422124 |
| Value | Count | Frequency (%) |
| 0 | 62630 | |
| 1 | 721 | 0.1% |
| 2 | 754 | 0.1% |
| 3 | 727 | 0.1% |
| 4 | 713 | 0.1% |
| 5 | 728 | 0.1% |
| 6 | 770 | 0.1% |
| 7 | 749 | 0.1% |
| 8 | 822 | 0.2% |
| 9 | 782 | 0.1% |
| Value | Count | Frequency (%) |
| 2027 | 1 | |
| 1752 | 1 | |
| 1560 | 1 | |
| 1486 | 1 | |
| 1439 | 1 | |
| 1397 | 1 | |
| 1363 | 1 | |
| 1309 | 1 | |
| 1216 | 1 | |
| 1211 | 1 |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 1/2/2023 12:00:00 AM | 9E | 4628 | 10529 | BDL | Hartford, CT | Connecticut | 11 | 12953 | LGA | New York, NY | New York | 22 | 800 | 757.0 | -3.0 | 11.0 | 20.0 | 905 | 853.0 | -12.0 | 0.0 | NaN | 0.0 | 25.0 | NaN | NaN | NaN | NaN | NaN |
| 1 | 1 | 1/2/2023 12:00:00 AM | 9E | 4630 | 11337 | DLH | Duluth, MN | Minnesota | 63 | 13487 | MSP | Minneapolis, MN | Minnesota | 63 | 510 | 502.0 | -8.0 | 29.0 | 15.0 | 626 | 622.0 | -4.0 | 0.0 | NaN | 0.0 | 36.0 | NaN | NaN | NaN | NaN | NaN |
| 2 | 1 | 1/2/2023 12:00:00 AM | 9E | 4633 | 13931 | ORF | Norfolk, VA | Virginia | 38 | 11433 | DTW | Detroit, MI | Michigan | 43 | 530 | 526.0 | -4.0 | 20.0 | 8.0 | 735 | 728.0 | -7.0 | 0.0 | NaN | 0.0 | 94.0 | NaN | NaN | NaN | NaN | NaN |
| 3 | 1 | 1/2/2023 12:00:00 AM | 9E | 4634 | 13487 | MSP | Minneapolis, MN | Minnesota | 63 | 14122 | PIT | Pittsburgh, PA | Pennsylvania | 23 | 910 | 911.0 | 1.0 | 36.0 | 4.0 | 1220 | 1219.0 | -1.0 | 0.0 | NaN | 0.0 | 88.0 | NaN | NaN | NaN | NaN | NaN |
| 4 | 1 | 1/2/2023 12:00:00 AM | 9E | 4634 | 14122 | PIT | Pittsburgh, PA | Pennsylvania | 23 | 13487 | MSP | Minneapolis, MN | Minnesota | 63 | 1310 | 1305.0 | -5.0 | 16.0 | 24.0 | 1440 | 1446.0 | 6.0 | 0.0 | NaN | 0.0 | 121.0 | NaN | NaN | NaN | NaN | NaN |
| 5 | 1 | 1/2/2023 12:00:00 AM | 9E | 4639 | 10397 | ATL | Atlanta, GA | Georgia | 34 | 12323 | ILM | Wilmington, NC | North Carolina | 36 | 855 | 852.0 | -3.0 | 20.0 | 4.0 | 1020 | 1051.0 | 31.0 | 0.0 | NaN | 0.0 | 95.0 | 0.0 | 0.0 | 31.0 | 0.0 | 0.0 |
| 6 | 1 | 1/2/2023 12:00:00 AM | 9E | 4639 | 12323 | ILM | Wilmington, NC | North Carolina | 36 | 10397 | ATL | Atlanta, GA | Georgia | 34 | 1100 | 1127.0 | 27.0 | 12.0 | 11.0 | 1241 | 1254.0 | 13.0 | 0.0 | NaN | 0.0 | 64.0 | NaN | NaN | NaN | NaN | NaN |
| 7 | 1 | 1/2/2023 12:00:00 AM | 9E | 4640 | 11003 | CID | Cedar Rapids/Iowa City, IA | Iowa | 61 | 13487 | MSP | Minneapolis, MN | Minnesota | 63 | 630 | 634.0 | 4.0 | 24.0 | 9.0 | 803 | 752.0 | -11.0 | 0.0 | NaN | 0.0 | 45.0 | NaN | NaN | NaN | NaN | NaN |
| 8 | 1 | 1/2/2023 12:00:00 AM | 9E | 4642 | 10397 | ATL | Atlanta, GA | Georgia | 34 | 10990 | CHO | Charlottesville, VA | Virginia | 38 | 1430 | 1422.0 | -8.0 | 14.0 | 4.0 | 1604 | 1549.0 | -15.0 | 0.0 | NaN | 0.0 | 69.0 | NaN | NaN | NaN | NaN | NaN |
| 9 | 1 | 1/2/2023 12:00:00 AM | 9E | 4646 | 12478 | JFK | New York, NY | New York | 22 | 14685 | SAV | Savannah, GA | Georgia | 34 | 1530 | 1545.0 | 15.0 | 26.0 | 5.0 | 1802 | 1801.0 | -1.0 | 0.0 | NaN | 0.0 | 105.0 | NaN | NaN | NaN | NaN | NaN |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 538827 | 7 | 1/29/2023 12:00:00 AM | YX | 5855 | 11278 | DCA | Washington, DC | Virginia | 38 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1130 | 1124.0 | -6.0 | 15.0 | 6.0 | 1301 | 1251.0 | -10.0 | 0.0 | NaN | 0.0 | 66.0 | NaN | NaN | NaN | NaN | NaN |
| 538828 | 7 | 1/29/2023 12:00:00 AM | YX | 5856 | 12953 | LGA | New York, NY | New York | 22 | 13931 | ORF | Norfolk, VA | Virginia | 38 | 1055 | 1049.0 | -6.0 | 19.0 | 6.0 | 1233 | 1215.0 | -18.0 | 0.0 | NaN | 0.0 | 61.0 | NaN | NaN | NaN | NaN | NaN |
| 538829 | 7 | 1/29/2023 12:00:00 AM | YX | 5857 | 12953 | LGA | New York, NY | New York | 22 | 11042 | CLE | Cleveland, OH | Ohio | 44 | 1710 | 1709.0 | -1.0 | 38.0 | 11.0 | 1907 | 1921.0 | 14.0 | 0.0 | NaN | 0.0 | 83.0 | NaN | NaN | NaN | NaN | NaN |
| 538830 | 7 | 1/29/2023 12:00:00 AM | YX | 5858 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11278 | DCA | Washington, DC | Virginia | 38 | 1215 | 1208.0 | -7.0 | 20.0 | 4.0 | 1408 | 1358.0 | -10.0 | 0.0 | NaN | 0.0 | 86.0 | NaN | NaN | NaN | NaN | NaN |
| 538831 | 7 | 1/29/2023 12:00:00 AM | YX | 5859 | 14730 | SDF | Louisville, KY | Kentucky | 52 | 11433 | DTW | Detroit, MI | Michigan | 43 | 735 | 728.0 | -7.0 | 12.0 | 24.0 | 910 | 853.0 | -17.0 | 0.0 | NaN | 0.0 | 49.0 | NaN | NaN | NaN | NaN | NaN |
| 538832 | 7 | 1/29/2023 12:00:00 AM | YX | 5860 | 12339 | IND | Indianapolis, IN | Indiana | 42 | 12953 | LGA | New York, NY | New York | 22 | 955 | 946.0 | -9.0 | 13.0 | 10.0 | 1204 | 1136.0 | -28.0 | 0.0 | NaN | 0.0 | 87.0 | NaN | NaN | NaN | NaN | NaN |
| 538833 | 7 | 1/29/2023 12:00:00 AM | YX | 5861 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11278 | DCA | Washington, DC | Virginia | 38 | 1015 | 1006.0 | -9.0 | 18.0 | 3.0 | 1211 | 1145.0 | -26.0 | 0.0 | NaN | 0.0 | 78.0 | NaN | NaN | NaN | NaN | NaN |
| 538834 | 7 | 1/29/2023 12:00:00 AM | YX | 5861 | 11278 | DCA | Washington, DC | Virginia | 38 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1259 | 1250.0 | -9.0 | 13.0 | 12.0 | 1440 | 1418.0 | -22.0 | 0.0 | NaN | 0.0 | 63.0 | NaN | NaN | NaN | NaN | NaN |
| 538835 | 7 | 1/29/2023 12:00:00 AM | YX | 5862 | 10785 | BTV | Burlington, VT | Vermont | 16 | 12953 | LGA | New York, NY | New York | 22 | 1115 | 1109.0 | -6.0 | 20.0 | 10.0 | 1239 | 1233.0 | -6.0 | 0.0 | NaN | 0.0 | 54.0 | NaN | NaN | NaN | NaN | NaN |
| 538836 | 7 | 1/29/2023 12:00:00 AM | YX | 5863 | 12478 | JFK | New York, NY | New York | 22 | 14321 | PWM | Portland, ME | Maine | 12 | 1330 | 1335.0 | 5.0 | 19.0 | 6.0 | 1453 | 1444.0 | -9.0 | 0.0 | NaN | 0.0 | 44.0 | NaN | NaN | NaN | NaN | NaN |